CREATE VIEW [fin].[eod_quotes_v] AS
SELECT	  qot_id			AS qov_qot_id
		, qot_sym_id		AS qov_sym_id
		, sym_cd			AS qov_sym_cd
		, sym_desc			AS qov_sym_desc
		, sym_exc_id		AS qov_exc_id
		, exc_cd			AS qov_exc_cd
		, exc_desc			AS qov_exc_desc
		, qot_cat_id		AS qov_cat_id
		, cat_cd			AS qov_cat_cd
		, cat_desc			AS qov_cat_desc
		, qot_trade_dt		AS qov_trade_dt
		, qot_open			AS qov_open
		, qot_high			AS qov_high
		, qot_low			AS qov_low
		, qot_close			AS qov_close
		, qot_volume		AS qov_volume
		, qot_open_interest	AS qov_open_interest
		, qot_adj_factor	AS qot_adj_factor
FROM	fin.eod_quotes qot
		INNER JOIN fin.eod_symbols sym ON (qot_sym_id = sym_id)
		INNER JOIN fin.eod_exchanges exc ON (sym_exc_id = exc_id)
		INNER JOIN fin.com_categories frq ON (qot_cat_id = cat_id);